Round 1 - Soft Skills (Recruiter Assessment)

SQL Basics (7 Questions):

Questions focusing on SQL clauses and concepts, including:

🔹 Understanding the differences between the HAVING and WHERE clauses.

🔹 Using SELF JOIN in SQL queries.

🔹 Applications of WINDOW functions.

🔹 Evaluating the benefits of indexing (True/False).

Data Modeling (Any 2 out of 5 Questions):

🔹 Questions on data modeling concepts, including:

🔹 Choosing between fact and dimension tables for a given problem scenario.

🔹 Implementation of Slowly Changing Dimension (SCD) Type 4.

🔹 Writing a query to track historical changes in data.

🔹 Discussing different loading strategies for incoming data.

Python Programming (1 Question):

🔹 Write a Python program to calculate the total amount spent, identify the top 5 users based on their spending, and find the most purchased product.

Round 2 - Technical Discussion

🔹Discussion focused on your past experiences and projects.

🔹Addressed challenges you faced at work and how you diagnosed and resolved them.

🔹Reviewed all unsolved technical questions from the written test and discussed solution approaches.

🔹Included three medium-level SQL questions, one involving two tables with values and nulls, requiring the output of LEFT, RIGHT, and INNER JOIN operations.

Round 3 - System Design

🔹Questions ranged from easy to medium, covering Apache Spark fundamentals, including cores, executors, jobs, stages, transformations vs. actions, etc.

🔹Discussed the differences between REPARTITION vs. COALESCE, optimization techniques, Delta vs. Parquet file formats, Z-Ordering, various JOIN strategies, and incremental loading using Delta file formats.

🔹Included one advanced scenario-based SQL question utilizing Common Table Expressions (CTEs) and conditional joins.

Round 4 - Hiring Manager

🔹Discussed your past experiences, projects, and challenges you faced.

🔹Questions related to your knowledge and usage of Databricks services.

🔹Explored your reasons for wanting to switch from your current company.